To demonstrate this unit of competency the person will during the monitoring process give consideration to: Data migration from the legacy systems to the staging area (if necessary) Data conditioning, cleaning, transformation, and integration in the staging area Storing, updating and exporting converted data Data loading and indexing on the production server Ensuring data quality throughout the data conversion process Supplementary questioning may be used during the summative assessment phase, where necessary, to ensure that: Data is complete and valid Structural integrity of both the legacy system and the new database/data warehouse is sound Data reflects and works with the business rules and data standards An individual performing at this standard will display self-directed application of knowledge and skills, with substantial depth in database design and development where judgement is required in planning and selecting appropriate equipment, services and techniques for self and others. The breadth, depth and complexity covering planning and initiation of alternative approaches to skills or knowledge applications across a broad range of technical and/or management requirements, evaluation and coordination would be characteristic. Assessment must ensure: The demonstration of competency may also require self-directed application of knowledge and skills, with substantial depth in some areas where judgement is required in planning and selecting appropriate equipment, services and techniques for self and others. Applications involve participation in development of strategic initiatives as well as personal responsibility and autonomy in performing complex technical operations or organising others. It may include participation in teams including teams concerned with planning and evaluation functions. Group or team coordination may also be involved. |